package cn.tedu.v1.mapper;

import cn.tedu.v1.model.Doctors;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * 医生列表 Mapper 接口
 * </p>
 *
 * @author tedu.cn
 * @since 2021-07-06
 */
@Repository
public interface DoctorsMapper extends BaseMapper<Doctors> {
    @Select("SELECT  id, name,  gender,  email,  phone,  user_id, office_id, headimg_url,bloodtype,  birthday,  otherinfo FROM doctors WHERE office_id =#{officeId} and status=1" )
    List<Doctors> selectDoctorsByOfficeId(Integer officeId);
}
